package com.ruoyi.mapper;

import com.ruoyi.domain.T10T;
import com.ruoyi.entity.DTO.T10DTO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import java.sql.Date;
import java.util.List;


@Mapper
public interface T10TMapper {

    @Select("select sum(F1002) from T10 where F1003 = #{F1003}")
    int selectT10(Date F1003) ;
    @Select("select sum(F1002) from T10")
    int selectT10Sum();

    @Select("select F1102 from T10 a, T11 b , T03 c where a.F0301 = b.F0301 and b.F0301 = c.F0301" +
            " group by a.F0301 order by sum(F1002) desc limit 1")
    String MaxF1102();

    List<T10T> selectT10List(T10DTO t10);
}
